-- @owner: @zou_jialiang050
-- @date: 2022/09/15
-- @testpoint: show create function指定错误function名，合理报错

--step1:创建表及函数;expect:成功
drop table if exists t_show_create_function_0009;
create table t_show_create_function_0009(c1 int,c2 int,c3 int);

create or replace function f_show_create_function_0009() returns trigger as
$$
declare
begin
    insert into t_show_create_function_0009 values(new.id1, new.id2, new.id3);
    return new;
end
$$ language plpgsql;
/

--step2:show create function指定错误function名;expect:合理报错
show create function f_show_create_function_0009_1;

--step3:清理环境;expect:成功
drop function if exists f_show_create_function_0009;
drop table if exists t_show_create_function_0009;
